﻿CREATE TABLE [dbo].[ArticoleVariante] (
    [IDVariantaArticol] INT             IDENTITY (1, 1) NOT NULL,
    [IDArticol]         INT             NOT NULL,
    [Denumire]          VARCHAR (100)   NOT NULL,
    [PretVanzare]       DECIMAL (18, 2) CONSTRAINT [DF_ArticoleVariante_PretVanzare] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_ArticoleVariante] PRIMARY KEY CLUSTERED ([IDVariantaArticol] ASC),
    CONSTRAINT [FK_ArticoleVariante_Articole] FOREIGN KEY ([IDArticol]) REFERENCES [dbo].[Articole] ([IDArticol])
);

